package database;

public final class CreateDbStatements {

    public static final String createTablePlayer =
        "create table app.player (" +
        "    id          integer not null primary key generated always as identity (start with 1, increment by 1)," +
        "    lastname    varchar(30), " +
        "    firstname   varchar(30), " +
        "    middlename  varchar(30), " +
        "    phone       varchar(20), " +
        "    email       varchar(30), " +
        "    address1    varchar(30), " +
        "    address2    varchar(30), " +
        "    city        varchar(30), " +
        "    state       varchar(30), " +
        "    postalcode  varchar(20), " +
        "    country     varchar(30) " +
        ")";
	
}
